package com.neusoft.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

public interface HomeMapper {
	@Select("select empno from emp where deptno=#{deptno}")
	public List<Integer> getempno(Integer deptno);
	@Select("SELECT COUNT(*) FROM reattendace WHERE restate=-1 AND empno=#{empno}")
	public Integer getsum(Integer empno);
	@Select("SELECT COUNT(*) FROM vacation_record WHERE state=-1 AND empno=#{empno}")
	public Integer getsum2(Integer empno);
	
}
